Creating a Dimension of the Structured Type

You want to create a structured text field to ensure that cost centers are always entered in the predefined format XX-123.4567_8X0 in the input field.

1. Starting from the top navigation, click > Planner > Settings > Dimensions.

2. Choose Add new Dimension.

A dialog box opens.

3. Enter a name.

4. If necessary, enter information text. Use the formatting functions to display complex descriptions clearly.

5. From the Base type dropdown list, select the Structured entry.

6. Click on the Edit structure field.

The Regular expression structure dialog box opens.

7. Choose

   • Use the Editor to create a rule:

     1. Click Add new regular expression.

     A line with input fields opens.

     2. Select Letters as the variable.

     3. In the Length column, enter the value 2.

     4. Select a dash (-) from the Separator dropdown list.

     5. Click Add new regular expression.

     6. Select Numbers as the variable for the second input field.

     7. In the Length column, enter the value 3.

     8. Select a period (.) from the Separator dropdown list.

     9. Click Add new regular expression.

     10. Select Numbers as the variable for the third input field.

     11. In the Length column, enter the value 4.

     12. Select an underscore (_) from the Separator dropdown list.

     13. Click Add new regular expression.

     14. Select Letters, Numbers as the variable for the fourth input field.

     15. In the Length column, enter the value 3.

   • You enter a regular expression (regex).

     1. Activate the User defined structure checkbox.

     2. Enter the regular expression in the input field below the checkbox.

8. Click Save

9. Edit the attributes.

10. Choose which User groups have access to the dimension.

11. Click Save.

You have created a dimension with a structured text dimension, in which users can enter a cost center in a predefined format only.